Calculated Columns Settings

The custom column settings define the save context of the custom column (i.e., in which table the resulting virtual column should appear) and a number of other properties of the custom column:

  • Column Name the name of the new calculated column.
  • Parent Table: the name of the table in which the new calculated column will exist. Defaults to the name of the table being edited and cannot be changed.
  • Hide Attribute: a check box to optionally hide the new virtual column.
  • Display Folder: defines how the custom column appears in the Discover Dimensions elements panel.
  • Sort By Column: sets default sorting of the values (Members) in the calculated custom column. See Column Configuration for more details.
  • Category Type: sets the category of the attribute, such as Date (Years, Months, Weeks etc.), Geographic (Latitude / Longitude, Country, State, etc.). See Column Configuration for more details.